{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Anleitung","VORLAGE","Kursliste"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Anleitung","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["1. ","In der Vorlage die Überschrift anpassen"]
["2.","In der Vorlage die Aufgabennummern und zu erreichenden BE anpassen ans aktuelle Abi"]
["3.","In der Vorlage die automatische Summierung und Zellenfärbung (bedingte Formatierung) prüfen - passen die Bereiche noch?"]
["4.","Kursliste eintragen und dort unten  \"Vorlage zu Blättern kopieren\" anklicken"]
["5.","Jeweils die BE eintragen. Abweichungen zwischen Erst- und Zweitkorrektor werden automatisch farbig hervorgehoben. Ebenso, wenn versehentlich mehr BE als möglich gegeben werden."]
["6.","Notenzuordnung erfolgt automatisch - dennoch liegt Verantwortung bei der Lehrkraft. In der Kursliste wird automatisch die Übersicht erstellt."]
["7.","Excel kann \"alle Blätter drucken\". Soll dies z.B. verkleinert oder schwarz-weiß erfolgen, drucke man zunächst alles in ein PDF und drucke dann dieses entsprechend aus. Andernfalls gelten die Treibereinstellungen leider nur für das erste Blatt."]
[]
["Hinweis:"]
["Auch halbe BE können eingegeben werden. In diesem Fall kann aber die automatisch bei den Notenpunkten angezeigte Tendenz falsch sein. Diese"]
["zeigt nämlich nur \"+\" an, wenn die BE-Anzahl um genau 1 unter der Grenze liegt."]

{"sheet":"VORLAGE","index":1,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Mathematik Abitur 2022",null,"Kurs:","2m1"]
[]
["Name:",null,null,null,null,null,{"$f":"IF(B3<>\"\",B3,\"-\")","v":"-"}]
[]
["Teilgebiet","Aufgabe","BE max","BE 1.Ko.",null,"BE 2.Ko.","Kommentar"]
["A - Analysis","1a",3]
[null,"1b",3]
[null,"2a",2]
[null,"2b",2]
[null,"3a",2]
[null,"3b",3]
[null,"4a",2]
[null,"4b",3]
[null,"SUMME",{"$f":"SUM(C6:C13)","v":20},{"$f":"SUM(D6:D13)","v":0},null,{"$f":"SUM(F6:F13)","v":0}]
["A - Stochastik","a",2]
[null,"b",3]
[null,"SUMME",{"$f":"SUM(C15:C16)","v":5},{"$f":"SUM(D15:D16)","v":0},null,{"$f":"SUM(F15:F16)","v":0}]
["A - Geometrie","a",4]
[null,"b",1]
[null,"SUMME",{"$f":"SUM(C18:C19)","v":5},{"$f":"SUM(D18:D19)","v":0},null,{"$f":"SUM(F18:F19)","v":0}]
["B - Analysis","1a",2]
[null,"1b",4]
[null,"1c",4]
[null,"1d",2]
[null,"1e",3]
[null,"1f",2]
[null,"1g",2]
[null,"1h",3]
[null,"1i",2]
[null,"2a",5]
[null,"2b",3]
[null,"2c",2]
[null,"2d",6]
[null,"SUMME",{"$f":"SUM(C21:C33)","v":40},{"$f":"SUM(D21:D33)","v":0},null,{"$f":"SUM(F21:F33)","v":0}]
["B - Stochastik","1",3]
[null,"2a",3]
[null,"2b",2]
[null,"2c",4]
[null,"3a",3]
[null,"3b",3]
[null,"3c",2]
[null,"4a",3]
[null,"4b",2]
[null,"SUMME",{"$f":"SUM(C35:C43)","v":25},{"$f":"SUM(D35:D43)","v":0},null,{"$f":"SUM(F35:F43)","v":0}]
["B - Geometrie","a",4]
[null,"b",3]
[null,"c",2]
[null,"d",4]
[null,"e",2]
[null,"f",4]
[null,"g",2]
[null,"h",4]
[null,"SUMME",{"$f":"SUM(C45:C52)","v":25},{"$f":"SUM(D45:D52)","v":0},null,{"$f":"SUM(F45:F52)","v":0}]
[]
["Analysis","SUMME",{"$f":"C14+C34","v":60},{"$f":"D14+D34","v":0},null,{"$f":"F14+F34","v":0}]
["Stochastik","SUMME",{"$f":"C17+C44","v":30},{"$f":"D17+D44","v":0},null,{"$f":"F17+F44","v":0}]
["Geometrie","SUMME",{"$f":"C20+C53","v":30},{"$f":"D20+D53","v":0},null,{"$f":"F20+F53","v":0}]
[]
["Insgesamt","SUMME",{"$f":"SUM(C55:C57)","v":120},{"$f":"SUM(D55:D57)","v":0},null,0]
[null,null,null,{"$f":"IF(OR(D59=114,D59=108,D59=102,D59=96,D59=90,D59=84,D59=78,D59=72,D59=66,D59=60,D59=54,D59=48,D59=40,D59=32,D59=24),\"-\",\"\") & IF(OR(D59=113,D59=107,D59=101,D59=95,D59=89,D59=83,D59=77,D59=71,D59=65,D59=59,D59=53,D59=47,D59=39,D59=31,D59=23),\"+\",\"\")","v":""},null,{"$f":"IF(OR(F59=114,F59=108,F59=102,F59=96,F59=90,F59=84,F59=78,F59=72,F59=66,F59=60,F59=54,F59=48,F59=40,F59=32,F59=24),\"-\",\"\") & IF(OR(F59=113,F59=107,F59=101,F59=95,F59=89,F59=83,F59=77,F59=71,F59=65,F59=59,F59=53,F59=47,F59=39,F59=31,F59=23),\"+\",\"\")","v":""}]
["Notenpunkte",null,null,{"$f":"IF(D59>=114,15,IF(D59>=108,14,IF(D59>=102,13,IF(D59>=96,12,IF(D59>=90,11,IF(D59>=84,10,IF(D59>=78,9,IF(D59>=72,8,IF(D59>=66,7,IF(D59>=60,6,IF(D59>=54,5,IF(D59>=48,4,IF(D59>=40,3,IF(D59>=32,2,IF(D59>=24,1,0)))))))))))))))","v":0},null,{"$f":"IF(F59>=114,15,IF(F59>=108,14,IF(F59>=102,13,IF(F59>=96,12,IF(F59>=90,11,IF(F59>=84,10,IF(F59>=78,9,IF(F59>=72,8,IF(F59>=66,7,IF(F59>=60,6,IF(F59>=54,5,IF(F59>=48,4,IF(F59>=40,3,IF(F59>=32,2,IF(F59>=24,1,0)))))))))))))))","v":0}]

{"sheet":"Kursliste","index":2,"n_rows":46,"n_cols":24,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[{"$f":"VORLAGE!A1","v":"Mathematik Abitur 2022"},null,"Kurs:",{"$f":"VORLAGE!D1","v":"2m1"},null,null,null,"Vergleich"]
["Nr","Name","Notenpunkte (Erstkorrektor)",null,null,null,"Nr.","Name","NP (Erst)","NP (Zweit)",null,"BE (Erst)","BE (Zweit)",null,"AnaBE (Erst)","AnaBE (Zweit)","StoBE (Erst)","StoBE (Zweit)","GeoBE (Erst)","GeoBE (Zweit)"]
[1,null,null,{"$f":"IF(C3=\"\",\"\",IF(C3=15,\"+1 sehr gut\", IF(C3=14,\"1 sehr gut\", IF(C3=13,\"1- sehr gut\", IF(C3=12,\"+2 gut\", IF(C3=11,\"2 gut\", IF(C3=10,\"2- gut\", IF(C3=9,\"+3 befriedigend\", IF(C3=8,\"3 befriedigend\", IF(C3=7,\"3- befriedigend\", IF(C3=6,\"+4 ausreichend\", IF(C3=5,\"4 ausreichend\", IF(C3=4,\"4- ausreichend\", IF(C3=3,\"+5 mangelhaft\", IF(C3=2,\"5 mangelhaft\", IF(C3=1,\"5- mangelhaft\", \"6 ungenügend\"))))))))))))))))","v":""},null,null,{"$f":"A3","v":1},{"$f":"IF(B3<>\"\",B3,\"\")","v":""}]
[2,null,null,{"$f":"IF(C4=\"\",\"\",IF(C4=15,\"+1 sehr gut\", IF(C4=14,\"1 sehr gut\", IF(C4=13,\"1- sehr gut\", IF(C4=12,\"+2 gut\", IF(C4=11,\"2 gut\", IF(C4=10,\"2- gut\", IF(C4=9,\"+3 befriedigend\", IF(C4=8,\"3 befriedigend\", IF(C4=7,\"3- befriedigend\", IF(C4=6,\"+4 ausreichend\", IF(C4=5,\"4 ausreichend\", IF(C4=4,\"4- ausreichend\", IF(C4=3,\"+5 mangelhaft\", IF(C4=2,\"5 mangelhaft\", IF(C4=1,\"5- mangelhaft\", \"6 ungenügend\"))))))))))))))))","v":""},null,null,{"$f":"A4","v":2},{"$f":"IF(B4<>\"\",B4,\"\")","v":""}]
[3,null,null,"",null,null,3,""]
[4,null,null,"",null,null,4,""]
[5,null,null,"",null,null,5,""]
[6,null,null,"",null,null,6,""]
[7,null,null,"",null,null,7,""]
[8,null,null,"",null,null,8,""]
[9,null,null,"",null,null,9,""]
[10,null,null,"",null,null,10,""]
[11,null,null,"",null,null,11,""]
[12,null,null,"",null,null,12,""]
[13,null,null,"",null,null,13,""]
[14,null,null,"",null,null,14,""]
[15,null,null,"",null,null,15,""]
[16,null,null,"",null,null,16,""]
[17,null,null,"",null,null,17,""]
[18,null,null,"",null,null,18,""]
[19,null,null,"",null,null,19,""]
[20,null,null,"",null,null,20,""]
[21,null,null,"",null,null,21,""]
[22,null,null,"",null,null,22,""]
[23,null,null,"",null,null,23,""]
[24,null,null,"",null,null,24,""]
[25,null,null,"",null,null,25,""]
[26,null,null,"",null,null,26,""]
[27,null,null,"",null,null,27,""]
[28,null,null,"",null,null,28,""]
[29,null,null,"",null,null,29,""]
[30,null,null,"",null,null,30,""]
[31,null,null,"",null,null,31,""]
[32,null,null,"",null,null,32,""]
[33,null,null,"",null,null,33,""]
[]
[null,"MITTELWERT=",{"$f":"AVERAGE(C3:C35)","v":{"$error":"#DIV/0!"}},null,null,null,null,"Erstkorrektor-Übersicht:"]
[null,"Notenschnitt (17-NP):3=",{"$f":"(17-C37)/3","v":{"$error":"#DIV/0!"}},null,null,null,null,"Notenpunkte",15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0]
[null,null,null,null,null,null,null,"Anzahl",{"$f":"COUNTIF($C$3:$C$35,I38)","v":0},{"$f":"COUNTIF($C$3:$C$35,J38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,"Note",null,1,null,null,2,null,null,3,null,null,4,null,null,5,null,6]
[null,"VORSICHT BEIM DRUCKEN:",null,null,null,null,null,"Anzahl",null,{"$f":"SUM(I39:K39)","v":0},null,null,{"$f":"SUM(L39:N39)","v":0},null,null,{"$f":"SUM(O39:Q39)","v":0},null,null,{"$f":"SUM(R39:T39)","v":0},null,null,{"$f":"SUM(U39:W39)","v":0},null,{"$f":"X39","v":0}]
[null,"Wählt man \"alle Arbeitsblätter drucken\", so gelten die "]
[null,"Einstellungen des Druckertreibers nur für das gerade aktive Blatt."]
[null,"Das betrifft z.B. Farb/Schwarzweiß oder auch Mehrere auf einer Seite"]
[null,"Trick: Alles erst in ein großes PDF drucken lassen…"]